﻿using System;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using DAL;
using MOD;

namespace BLL
{
    public class B_LiShiShuJu
    {
        private int iDataConn = DataBase.IN_S2;
        public  DataTable GetNewShuJu( M_LiShiShuJu mLssj,DateTime dDt1,DateTime dDt2,Int32 iServerType )
        {
            DataBase dDb = new DataBase();
            StringBuilder sCmdText = new StringBuilder();
            iDataConn = iServerType;

            sCmdText.Append("SpLiShiShuJuCarXiTong");
          
            SqlParameter[] sSp = {
                                    new SqlParameter("@p_CheId",SqlDbType.Int),
                                    new SqlParameter("@p_Begin",SqlDbType.DateTime),
                                    new SqlParameter("@p_End",SqlDbType.DateTime)
                                 };

            sSp[0].Value = mLssj.CheId;
            sSp[1].Value = dDt1;
            sSp[2].Value = dDt2;

            return dDb.GetDataTable(sCmdText.ToString(), iDataConn, sSp);
        }
    }
}
